Running a one-way ANOVA followed by multiple comparisons tests with XLSTAT

An Excel sheet with both the data and the results can be downloaded by clicking here. The data correspond to an experiment where 4 new toothpaste formulas were each tested on 6 different patients in order to measure their effect on the whiteness of teeth. All patients had previously used the same toothpaste. Using the ANOVA function of XLSTAT we want to find out if the results differ according to the formula used and, if so, which formula is the most effective. The case is a one-way balanced ANOVA because there is only one factor-the formula-and the number of repetitions is the same for each formula. Once XLSTAT is open, select the XLSTAT / Modeling data / ANOVA command, or click on the corresponding button of the Modeling Data toolbar (see below). Once you have clicked on the button, the ANOVA dialog box appears. Select the data on the Excel sheet. To the Dependent variable corresponds here "Whiteness" which variability we want to explain by the effect of the "Toothpaste" formula, the latter being the Qualitative explanatory variable. As we selected the column title for both variables, we also clicked on the option Variable labels.